4 sudo
-u postgres psql template1
-a -f - <<-EOF
6 DO LANGUAGE plpgsql \$\$
10 FROM pg_catalog.pg_user
11 WHERE usename = '$owner'
24 case $
(sudo
-u postgres psql template1
-t -c \
25 "SELECT datname FROM pg_catalog.pg_database WHERE datname = '$db' LIMIT 1") in
28 sudo
-u postgres psql template1
-a -f - <<-EOF
30 CREATE DATABASE $db WITH OWNER=$owner;
34 sudo
-u postgres psql template1
-a -f - <<-EOF
36 REVOKE ALL ON DATABASE $db FROM public;
38 sudo
-u postgres psql
"$db" -a -f - <<-EOF
40 GRANT ALL ON SCHEMA public TO $owner WITH GRANT OPTION;